﻿Imports System.Data.SqlClient
Imports MySql.Data.MySqlClient

Public Class frmHangHoa
    Inherits System.Windows.Forms.Form
#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        'This call is required by the Windows Form Designer.
        InitializeComponent()

        'Add any initialization after the InitializeComponent() call

    End Sub

    'Form overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    Friend WithEvents btnNew As System.Windows.Forms.Button
    Friend WithEvents btnSave As System.Windows.Forms.Button
    Friend WithEvents btnDelete1 As System.Windows.Forms.Button
    Friend WithEvents BtnClose As System.Windows.Forms.Button
    Friend WithEvents TxtHanDung As System.Windows.Forms.TextBox
    Friend WithEvents Label10 As System.Windows.Forms.Label
    Friend WithEvents TxtMax As System.Windows.Forms.TextBox
    Friend WithEvents Label9 As System.Windows.Forms.Label
    Friend WithEvents TxtMin As System.Windows.Forms.TextBox
    Friend WithEvents Label8 As System.Windows.Forms.Label
    Friend WithEvents TxtGiaSYT As System.Windows.Forms.TextBox
    Friend WithEvents Label7 As System.Windows.Forms.Label
    Friend WithEvents TxtGiaBan As System.Windows.Forms.TextBox
    Friend WithEvents Label6 As System.Windows.Forms.Label
    Friend WithEvents TxtTenNhomHH As System.Windows.Forms.TextBox
    Friend WithEvents Label5 As System.Windows.Forms.Label
    Friend WithEvents txtTen_HD As System.Windows.Forms.TextBox
    Friend WithEvents txtTen_BD As System.Windows.Forms.TextBox
    Friend WithEvents txtMa_HH As System.Windows.Forms.TextBox
    Friend WithEvents Label4 As System.Windows.Forms.Label
    Friend WithEvents Label3 As System.Windows.Forms.Label
    Friend WithEvents Label2 As System.Windows.Forms.Label
    Friend WithEvents Label1 As System.Windows.Forms.Label
    '  Friend WithEvents DataGridView1 As System.Windows.Forms.DataGridView
    Friend WithEvents DataGridView1 As MyDataGridView
    Friend WithEvents DataSetForm_Don As MEKONG.DataSetForm_Don
    Friend WithEvents TxtQC_Thung As System.Windows.Forms.TextBox
    Friend WithEvents Label12 As System.Windows.Forms.Label
    Friend WithEvents TxtDV_Thung As System.Windows.Forms.TextBox
    Friend WithEvents TxtDV_Chan As System.Windows.Forms.TextBox
    Friend WithEvents TxtQC_Chan As System.Windows.Forms.TextBox
    Friend WithEvents TxtDV_Le As System.Windows.Forms.TextBox
    Friend WithEvents TxtQC_Le As System.Windows.Forms.TextBox
    Friend WithEvents CboNhomHH As MTGCComboBox
    Friend WithEvents CboNhomDC As MTGCComboBox
    Friend WithEvents TxtTenNhomDC As System.Windows.Forms.TextBox
    Friend WithEvents Label13 As System.Windows.Forms.Label
    Friend WithEvents TxtChietKhau As System.Windows.Forms.TextBox
    Friend WithEvents Label14 As System.Windows.Forms.Label
    Friend WithEvents DataSetFormDonBindingSource As System.Windows.Forms.BindingSource
    Friend WithEvents TabMain As System.Windows.Forms.TabControl
    Friend WithEvents TabThongTin As System.Windows.Forms.TabPage
    Friend WithEvents TabTimKiem As System.Windows.Forms.TabPage
    Friend WithEvents Label16 As System.Windows.Forms.Label
    Friend WithEvents txtMaSearch As System.Windows.Forms.TextBox
    Friend WithEvents btnTimKiem As System.Windows.Forms.Button
    Friend WithEvents txtTenSearch As System.Windows.Forms.TextBox
    Friend WithEvents Label11 As System.Windows.Forms.Label
    Friend WithEvents DataSetSearch As MEKONG.DataSetSearch
    ' Friend WithEvents gridSearch As System.Windows.Forms.DataGridView
    Friend WithEvents gridSearch As MyDataGridView
    Friend WithEvents DataSetSearchBindingSource As System.Windows.Forms.BindingSource
    Friend WithEvents Label17 As System.Windows.Forms.Label
    Friend WithEvents txtDieuKien As System.Windows.Forms.TextBox
    Friend WithEvents Label15 As System.Windows.Forms.Label
    Friend WithEvents txtSDK As System.Windows.Forms.TextBox
    Friend WithEvents MahanghoaDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents TenbietduocDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents TenhoaduocDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DonvithungDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents QuicachthungDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DonvibanchanDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents QuicachbanchanDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DonvibanleDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents QuicachbanleDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DongiaboDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DongiabanDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ChietkhauDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ManhomhanghoaDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MaduocchinhDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents HandungDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MinDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MaxDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DataGridViewTextBoxColumn2 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MahanghoaDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents TenbietduocDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents TenhoaduocDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DonvithungDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents QuicachthungDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DonvibanchanDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents QuicachbanchanDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DonvibanleDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents QuicachbanleDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DongiaboDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DongiabanDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ChietkhauDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ManhomhanghoaDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MaduocchinhDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents HandungDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MinDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MaxDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents sdk As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents dkbaoquan As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents Button1 As System.Windows.Forms.Button
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.components = New System.ComponentModel.Container
        Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(frmHangHoa))
        Dim DataGridViewCellStyle1 As System.Windows.Forms.DataGridViewCellStyle = New System.Windows.Forms.DataGridViewCellStyle
        Dim DataGridViewCellStyle2 As System.Windows.Forms.DataGridViewCellStyle = New System.Windows.Forms.DataGridViewCellStyle
        Dim DataGridViewCellStyle3 As System.Windows.Forms.DataGridViewCellStyle = New System.Windows.Forms.DataGridViewCellStyle
        Dim DataGridViewCellStyle4 As System.Windows.Forms.DataGridViewCellStyle = New System.Windows.Forms.DataGridViewCellStyle
        Dim DataGridViewCellStyle5 As System.Windows.Forms.DataGridViewCellStyle = New System.Windows.Forms.DataGridViewCellStyle
        Dim DataGridViewCellStyle6 As System.Windows.Forms.DataGridViewCellStyle = New System.Windows.Forms.DataGridViewCellStyle
        Dim DataGridViewCellStyle7 As System.Windows.Forms.DataGridViewCellStyle = New System.Windows.Forms.DataGridViewCellStyle
        Dim DataGridViewCellStyle8 As System.Windows.Forms.DataGridViewCellStyle = New System.Windows.Forms.DataGridViewCellStyle
        Me.btnSave = New System.Windows.Forms.Button
        Me.btnNew = New System.Windows.Forms.Button
        Me.btnDelete1 = New System.Windows.Forms.Button
        Me.BtnClose = New System.Windows.Forms.Button
        Me.Button1 = New System.Windows.Forms.Button
        Me.TxtHanDung = New System.Windows.Forms.TextBox
        Me.Label10 = New System.Windows.Forms.Label
        Me.TxtMax = New System.Windows.Forms.TextBox
        Me.Label9 = New System.Windows.Forms.Label
        Me.TxtMin = New System.Windows.Forms.TextBox
        Me.Label8 = New System.Windows.Forms.Label
        Me.TxtGiaSYT = New System.Windows.Forms.TextBox
        Me.Label7 = New System.Windows.Forms.Label
        Me.TxtGiaBan = New System.Windows.Forms.TextBox
        Me.Label6 = New System.Windows.Forms.Label
        Me.TxtTenNhomHH = New System.Windows.Forms.TextBox
        Me.Label5 = New System.Windows.Forms.Label
        Me.txtTen_HD = New System.Windows.Forms.TextBox
        Me.txtTen_BD = New System.Windows.Forms.TextBox
        Me.txtMa_HH = New System.Windows.Forms.TextBox
        Me.Label4 = New System.Windows.Forms.Label
        Me.Label3 = New System.Windows.Forms.Label
        Me.Label2 = New System.Windows.Forms.Label
        Me.Label1 = New System.Windows.Forms.Label
        Me.DataGridView1 = New MEKONG.MyDataGridView
        Me.DataSetFormDonBindingSource = New System.Windows.Forms.BindingSource(Me.components)
        Me.DataSetForm_Don = New MEKONG.DataSetForm_Don
        Me.TxtQC_Thung = New System.Windows.Forms.TextBox
        Me.Label12 = New System.Windows.Forms.Label
        Me.TxtDV_Thung = New System.Windows.Forms.TextBox
        Me.TxtDV_Chan = New System.Windows.Forms.TextBox
        Me.TxtQC_Chan = New System.Windows.Forms.TextBox
        Me.TxtDV_Le = New System.Windows.Forms.TextBox
        Me.TxtQC_Le = New System.Windows.Forms.TextBox
        Me.CboNhomHH = New MTGCComboBox
        Me.CboNhomDC = New MTGCComboBox
        Me.TxtTenNhomDC = New System.Windows.Forms.TextBox
        Me.Label13 = New System.Windows.Forms.Label
        Me.TxtChietKhau = New System.Windows.Forms.TextBox
        Me.Label14 = New System.Windows.Forms.Label
        Me.TabMain = New System.Windows.Forms.TabControl
        Me.TabThongTin = New System.Windows.Forms.TabPage
        Me.Label17 = New System.Windows.Forms.Label
        Me.txtDieuKien = New System.Windows.Forms.TextBox
        Me.Label15 = New System.Windows.Forms.Label
        Me.txtSDK = New System.Windows.Forms.TextBox
        Me.TabTimKiem = New System.Windows.Forms.TabPage
        Me.Label16 = New System.Windows.Forms.Label
        Me.txtMaSearch = New System.Windows.Forms.TextBox
        Me.btnTimKiem = New System.Windows.Forms.Button
        Me.txtTenSearch = New System.Windows.Forms.TextBox
        Me.Label11 = New System.Windows.Forms.Label
        Me.gridSearch = New MEKONG.MyDataGridView
        Me.MahanghoaDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.TenbietduocDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.TenhoaduocDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DonvithungDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.QuicachthungDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DonvibanchanDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.QuicachbanchanDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DonvibanleDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.QuicachbanleDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DongiaboDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DongiabanDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.ChietkhauDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.ManhomhanghoaDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MaduocchinhDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.HandungDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MinDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MaxDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DataGridViewTextBoxColumn2 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DataSetSearchBindingSource = New System.Windows.Forms.BindingSource(Me.components)
        Me.DataSetSearch = New MEKONG.DataSetSearch
        Me.MahanghoaDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.TenbietduocDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.TenhoaduocDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DonvithungDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.QuicachthungDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DonvibanchanDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.QuicachbanchanDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DonvibanleDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.QuicachbanleDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DongiaboDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DongiabanDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.ChietkhauDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.ManhomhanghoaDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MaduocchinhDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.HandungDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MinDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MaxDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.sdk = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.dkbaoquan = New System.Windows.Forms.DataGridViewTextBoxColumn
        CType(Me.DataGridView1, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.DataSetFormDonBindingSource, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.DataSetForm_Don, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.TabMain.SuspendLayout()
        Me.TabThongTin.SuspendLayout()
        Me.TabTimKiem.SuspendLayout()
        CType(Me.gridSearch, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.DataSetSearchBindingSource, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.DataSetSearch, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'btnSave
        '
        Me.btnSave.BackColor = System.Drawing.Color.Transparent
        Me.btnSave.Image = CType(resources.GetObject("btnSave.Image"), System.Drawing.Image)
        Me.btnSave.Location = New System.Drawing.Point(313, 534)
        Me.btnSave.Name = "btnSave"
        Me.btnSave.Size = New System.Drawing.Size(96, 24)
        Me.btnSave.TabIndex = 19
        Me.btnSave.UseVisualStyleBackColor = False
        '
        'btnNew
        '
        Me.btnNew.Image = CType(resources.GetObject("btnNew.Image"), System.Drawing.Image)
        Me.btnNew.Location = New System.Drawing.Point(193, 534)
        Me.btnNew.Name = "btnNew"
        Me.btnNew.Size = New System.Drawing.Size(96, 24)
        Me.btnNew.TabIndex = 20
        '
        'btnDelete1
        '
        Me.btnDelete1.Image = CType(resources.GetObject("btnDelete1.Image"), System.Drawing.Image)
        Me.btnDelete1.Location = New System.Drawing.Point(433, 534)
        Me.btnDelete1.Name = "btnDelete1"
        Me.btnDelete1.Size = New System.Drawing.Size(88, 24)
        Me.btnDelete1.TabIndex = 29
        '
        'BtnClose
        '
        Me.BtnClose.Image = CType(resources.GetObject("BtnClose.Image"), System.Drawing.Image)
        Me.BtnClose.Location = New System.Drawing.Point(665, 534)
        Me.BtnClose.Name = "BtnClose"
        Me.BtnClose.Size = New System.Drawing.Size(88, 24)
        Me.BtnClose.TabIndex = 30
        '
        'Button1
        '
        Me.Button1.Image = CType(resources.GetObject("Button1.Image"), System.Drawing.Image)
        Me.Button1.Location = New System.Drawing.Point(553, 534)
        Me.Button1.Name = "Button1"
        Me.Button1.Size = New System.Drawing.Size(88, 24)
        Me.Button1.TabIndex = 21
        '
        'TxtHanDung
        '
        Me.TxtHanDung.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtHanDung.Location = New System.Drawing.Point(636, 123)
        Me.TxtHanDung.MaxLength = 10
        Me.TxtHanDung.Name = "TxtHanDung"
        Me.TxtHanDung.Size = New System.Drawing.Size(148, 22)
        Me.TxtHanDung.TabIndex = 16
        '
        'Label10
        '
        Me.Label10.Location = New System.Drawing.Point(526, 126)
        Me.Label10.Name = "Label10"
        Me.Label10.Size = New System.Drawing.Size(104, 18)
        Me.Label10.TabIndex = 74
        Me.Label10.Text = "Hạn dùng ( tháng )"
        '
        'TxtMax
        '
        Me.TxtMax.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtMax.Location = New System.Drawing.Point(373, 123)
        Me.TxtMax.MaxLength = 10
        Me.TxtMax.Name = "TxtMax"
        Me.TxtMax.Size = New System.Drawing.Size(144, 22)
        Me.TxtMax.TabIndex = 15
        '
        'Label9
        '
        Me.Label9.Location = New System.Drawing.Point(283, 126)
        Me.Label9.Name = "Label9"
        Me.Label9.Size = New System.Drawing.Size(76, 16)
        Me.Label9.TabIndex = 73
        Me.Label9.Text = "Số lượng Max"
        '
        'TxtMin
        '
        Me.TxtMin.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtMin.Location = New System.Drawing.Point(138, 123)
        Me.TxtMin.MaxLength = 10
        Me.TxtMin.Name = "TxtMin"
        Me.TxtMin.Size = New System.Drawing.Size(144, 22)
        Me.TxtMin.TabIndex = 14
        '
        'Label8
        '
        Me.Label8.Location = New System.Drawing.Point(53, 126)
        Me.Label8.Name = "Label8"
        Me.Label8.Size = New System.Drawing.Size(79, 17)
        Me.Label8.TabIndex = 72
        Me.Label8.Text = "Số lượng Min"
        '
        'TxtGiaSYT
        '
        Me.TxtGiaSYT.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtGiaSYT.Location = New System.Drawing.Point(373, 96)
        Me.TxtGiaSYT.MaxLength = 10
        Me.TxtGiaSYT.Name = "TxtGiaSYT"
        Me.TxtGiaSYT.Size = New System.Drawing.Size(144, 22)
        Me.TxtGiaSYT.TabIndex = 12
        '
        'Label7
        '
        Me.Label7.Location = New System.Drawing.Point(286, 98)
        Me.Label7.Name = "Label7"
        Me.Label7.Size = New System.Drawing.Size(81, 19)
        Me.Label7.TabIndex = 71
        Me.Label7.Text = "Đơn giá SYT"
        '
        'TxtGiaBan
        '
        Me.TxtGiaBan.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtGiaBan.Location = New System.Drawing.Point(138, 96)
        Me.TxtGiaBan.MaxLength = 10
        Me.TxtGiaBan.Name = "TxtGiaBan"
        Me.TxtGiaBan.Size = New System.Drawing.Size(144, 22)
        Me.TxtGiaBan.TabIndex = 11
        '
        'Label6
        '
        Me.Label6.Location = New System.Drawing.Point(61, 98)
        Me.Label6.Name = "Label6"
        Me.Label6.Size = New System.Drawing.Size(71, 19)
        Me.Label6.TabIndex = 70
        Me.Label6.Text = "Đơn giá bán"
        '
        'TxtTenNhomHH
        '
        Me.TxtTenNhomHH.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtTenNhomHH.Location = New System.Drawing.Point(215, 70)
        Me.TxtTenNhomHH.MaxLength = 10
        Me.TxtTenNhomHH.Name = "TxtTenNhomHH"
        Me.TxtTenNhomHH.Size = New System.Drawing.Size(180, 22)
        Me.TxtTenNhomHH.TabIndex = 57
        '
        'Label5
        '
        Me.Label5.Location = New System.Drawing.Point(42, 71)
        Me.Label5.Name = "Label5"
        Me.Label5.Size = New System.Drawing.Size(90, 19)
        Me.Label5.TabIndex = 69
        Me.Label5.Text = "Nhóm hàng hóa"
        '
        'txtTen_HD
        '
        Me.txtTen_HD.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtTen_HD.Location = New System.Drawing.Point(138, 42)
        Me.txtTen_HD.MaxLength = 100
        Me.txtTen_HD.Name = "txtTen_HD"
        Me.txtTen_HD.Size = New System.Drawing.Size(325, 22)
        Me.txtTen_HD.TabIndex = 2
        '
        'txtTen_BD
        '
        Me.txtTen_BD.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtTen_BD.Location = New System.Drawing.Point(341, 14)
        Me.txtTen_BD.MaxLength = 50
        Me.txtTen_BD.Name = "txtTen_BD"
        Me.txtTen_BD.Size = New System.Drawing.Size(443, 22)
        Me.txtTen_BD.TabIndex = 1
        '
        'txtMa_HH
        '
        Me.txtMa_HH.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtMa_HH.Location = New System.Drawing.Point(138, 14)
        Me.txtMa_HH.MaxLength = 10
        Me.txtMa_HH.Name = "txtMa_HH"
        Me.txtMa_HH.Size = New System.Drawing.Size(103, 22)
        Me.txtMa_HH.TabIndex = 0
        '
        'Label4
        '
        Me.Label4.Location = New System.Drawing.Point(50, 39)
        Me.Label4.Name = "Label4"
        Me.Label4.Size = New System.Drawing.Size(82, 19)
        Me.Label4.TabIndex = 67
        Me.Label4.Text = "Tên hóa dược"
        '
        'Label3
        '
        Me.Label3.Location = New System.Drawing.Point(257, 15)
        Me.Label3.Name = "Label3"
        Me.Label3.Size = New System.Drawing.Size(78, 19)
        Me.Label3.TabIndex = 66
        Me.Label3.Text = "Tên biệt dược "
        '
        'Label2
        '
        Me.Label2.Location = New System.Drawing.Point(59, 14)
        Me.Label2.Name = "Label2"
        Me.Label2.Size = New System.Drawing.Size(73, 19)
        Me.Label2.TabIndex = 65
        Me.Label2.Text = "Mã hàng hóa"
        Me.Label2.TextAlign = System.Drawing.ContentAlignment.TopRight
        '
        'Label1
        '
        Me.Label1.BackColor = System.Drawing.Color.Transparent
        Me.Label1.Font = New System.Drawing.Font("Microsoft Sans Serif", 15.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.Label1.Location = New System.Drawing.Point(331, 8)
        Me.Label1.Name = "Label1"
        Me.Label1.Size = New System.Drawing.Size(304, 24)
        Me.Label1.TabIndex = 64
        Me.Label1.Text = "DANH MỤC HÀNG HÓA"
        '
        'DataGridView1
        '
        Me.DataGridView1.AllowUserToAddRows = False
        Me.DataGridView1.AllowUserToDeleteRows = False
        Me.DataGridView1.AllowUserToResizeColumns = False
        Me.DataGridView1.AutoGenerateColumns = False
        Me.DataGridView1.BackgroundColor = System.Drawing.Color.LightBlue
        Me.DataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize
        Me.DataGridView1.Columns.AddRange(New System.Windows.Forms.DataGridViewColumn() {Me.MahanghoaDataGridViewTextBoxColumn, Me.TenbietduocDataGridViewTextBoxColumn, Me.TenhoaduocDataGridViewTextBoxColumn, Me.DonvithungDataGridViewTextBoxColumn, Me.QuicachthungDataGridViewTextBoxColumn, Me.DonvibanchanDataGridViewTextBoxColumn, Me.QuicachbanchanDataGridViewTextBoxColumn, Me.DonvibanleDataGridViewTextBoxColumn, Me.QuicachbanleDataGridViewTextBoxColumn, Me.DongiaboDataGridViewTextBoxColumn, Me.DongiabanDataGridViewTextBoxColumn, Me.ChietkhauDataGridViewTextBoxColumn, Me.ManhomhanghoaDataGridViewTextBoxColumn, Me.MaduocchinhDataGridViewTextBoxColumn, Me.HandungDataGridViewTextBoxColumn, Me.MinDataGridViewTextBoxColumn, Me.MaxDataGridViewTextBoxColumn, Me.sdk, Me.dkbaoquan})
        Me.DataGridView1.DataMember = "tbl_hanghoa"
        Me.DataGridView1.DataSource = Me.DataSetFormDonBindingSource
        Me.DataGridView1.Location = New System.Drawing.Point(1, 180)
        Me.DataGridView1.Name = "DataGridView1"
        Me.DataGridView1.ReadOnly = True
        Me.DataGridView1.RowHeadersWidth = 26
        Me.DataGridView1.Size = New System.Drawing.Size(969, 348)
        Me.DataGridView1.TabIndex = 76
        '
        'DataSetFormDonBindingSource
        '
        Me.DataSetFormDonBindingSource.DataSource = Me.DataSetForm_Don
        Me.DataSetFormDonBindingSource.Position = 0
        '
        'DataSetForm_Don
        '
        Me.DataSetForm_Don.DataSetName = "DataSetForm_Don"
        Me.DataSetForm_Don.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema
        '
        'TxtQC_Thung
        '
        Me.TxtQC_Thung.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtQC_Thung.Location = New System.Drawing.Point(537, 42)
        Me.TxtQC_Thung.MaxLength = 100
        Me.TxtQC_Thung.Name = "TxtQC_Thung"
        Me.TxtQC_Thung.Size = New System.Drawing.Size(40, 22)
        Me.TxtQC_Thung.TabIndex = 3
        Me.TxtQC_Thung.Text = "1"
        Me.TxtQC_Thung.TextAlign = System.Windows.Forms.HorizontalAlignment.Right
        '
        'Label12
        '
        Me.Label12.Location = New System.Drawing.Point(469, 45)
        Me.Label12.Name = "Label12"
        Me.Label12.Size = New System.Drawing.Size(58, 19)
        Me.Label12.TabIndex = 78
        Me.Label12.Text = "Qui cách"
        '
        'TxtDV_Thung
        '
        Me.TxtDV_Thung.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtDV_Thung.Location = New System.Drawing.Point(578, 42)
        Me.TxtDV_Thung.MaxLength = 100
        Me.TxtDV_Thung.Name = "TxtDV_Thung"
        Me.TxtDV_Thung.Size = New System.Drawing.Size(40, 22)
        Me.TxtDV_Thung.TabIndex = 4
        Me.TxtDV_Thung.Text = "thùng"
        Me.TxtDV_Thung.TextAlign = System.Windows.Forms.HorizontalAlignment.Center
        '
        'TxtDV_Chan
        '
        Me.TxtDV_Chan.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtDV_Chan.ForeColor = System.Drawing.Color.Blue
        Me.TxtDV_Chan.Location = New System.Drawing.Point(661, 42)
        Me.TxtDV_Chan.MaxLength = 100
        Me.TxtDV_Chan.Name = "TxtDV_Chan"
        Me.TxtDV_Chan.Size = New System.Drawing.Size(40, 22)
        Me.TxtDV_Chan.TabIndex = 6
        Me.TxtDV_Chan.Text = "hộp"
        Me.TxtDV_Chan.TextAlign = System.Windows.Forms.HorizontalAlignment.Center
        '
        'TxtQC_Chan
        '
        Me.TxtQC_Chan.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtQC_Chan.Location = New System.Drawing.Point(620, 42)
        Me.TxtQC_Chan.MaxLength = 100
        Me.TxtQC_Chan.Name = "TxtQC_Chan"
        Me.TxtQC_Chan.Size = New System.Drawing.Size(40, 22)
        Me.TxtQC_Chan.TabIndex = 5
        Me.TxtQC_Chan.Text = "30"
        Me.TxtQC_Chan.TextAlign = System.Windows.Forms.HorizontalAlignment.Right
        '
        'TxtDV_Le
        '
        Me.TxtDV_Le.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtDV_Le.Location = New System.Drawing.Point(743, 42)
        Me.TxtDV_Le.MaxLength = 100
        Me.TxtDV_Le.Name = "TxtDV_Le"
        Me.TxtDV_Le.Size = New System.Drawing.Size(40, 22)
        Me.TxtDV_Le.TabIndex = 8
        Me.TxtDV_Le.Text = "gói"
        Me.TxtDV_Le.TextAlign = System.Windows.Forms.HorizontalAlignment.Center
        '
        'TxtQC_Le
        '
        Me.TxtQC_Le.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtQC_Le.Location = New System.Drawing.Point(702, 42)
        Me.TxtQC_Le.MaxLength = 100
        Me.TxtQC_Le.Name = "TxtQC_Le"
        Me.TxtQC_Le.Size = New System.Drawing.Size(40, 22)
        Me.TxtQC_Le.TabIndex = 7
        Me.TxtQC_Le.Text = "20"
        Me.TxtQC_Le.TextAlign = System.Windows.Forms.HorizontalAlignment.Right
        '
        'CboNhomHH
        '
        Me.CboNhomHH.ArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboNhomHH.ArrowColor = System.Drawing.Color.Black
        Me.CboNhomHH.BindedControl = Nothing
        Me.CboNhomHH.BorderStyle = MTGCComboBox.TipiBordi.Fixed3D
        Me.CboNhomHH.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal
        Me.CboNhomHH.ColumnNum = 1
        Me.CboNhomHH.ColumnWidth = "121"
        Me.CboNhomHH.DisabledArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboNhomHH.DisabledArrowColor = System.Drawing.Color.LightGray
        Me.CboNhomHH.DisabledBackColor = System.Drawing.SystemColors.Control
        Me.CboNhomHH.DisabledBorderColor = System.Drawing.SystemColors.InactiveBorder
        Me.CboNhomHH.DisabledForeColor = System.Drawing.SystemColors.GrayText
        Me.CboNhomHH.DisplayMember = "Text"
        Me.CboNhomHH.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed
        Me.CboNhomHH.DropDownBackColor = System.Drawing.Color.FromArgb(CType(CType(193, Byte), Integer), CType(CType(210, Byte), Integer), CType(CType(238, Byte), Integer))
        Me.CboNhomHH.DropDownForeColor = System.Drawing.Color.Black
        Me.CboNhomHH.DropDownStyle = MTGCComboBox.CustomDropDownStyle.DropDown
        Me.CboNhomHH.DropDownWidth = 141
        Me.CboNhomHH.GridLineColor = System.Drawing.Color.LightGray
        Me.CboNhomHH.GridLineHorizontal = False
        Me.CboNhomHH.GridLineVertical = False
        Me.CboNhomHH.LoadingType = MTGCComboBox.CaricamentoCombo.ComboBoxItem
        Me.CboNhomHH.Location = New System.Drawing.Point(138, 70)
        Me.CboNhomHH.ManagingFastMouseMoving = True
        Me.CboNhomHH.ManagingFastMouseMovingInterval = 30
        Me.CboNhomHH.Name = "CboNhomHH"
        Me.CboNhomHH.SelectedItem = Nothing
        Me.CboNhomHH.SelectedValue = Nothing
        Me.CboNhomHH.Size = New System.Drawing.Size(76, 21)
        Me.CboNhomHH.TabIndex = 9
        '
        'CboNhomDC
        '
        Me.CboNhomDC.ArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboNhomDC.ArrowColor = System.Drawing.Color.Black
        Me.CboNhomDC.BindedControl = Nothing
        Me.CboNhomDC.BorderStyle = MTGCComboBox.TipiBordi.Fixed3D
        Me.CboNhomDC.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal
        Me.CboNhomDC.ColumnNum = 1
        Me.CboNhomDC.ColumnWidth = "121"
        Me.CboNhomDC.DisabledArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboNhomDC.DisabledArrowColor = System.Drawing.Color.LightGray
        Me.CboNhomDC.DisabledBackColor = System.Drawing.SystemColors.Control
        Me.CboNhomDC.DisabledBorderColor = System.Drawing.SystemColors.InactiveBorder
        Me.CboNhomDC.DisabledForeColor = System.Drawing.SystemColors.GrayText
        Me.CboNhomDC.DisplayMember = "Text"
        Me.CboNhomDC.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed
        Me.CboNhomDC.DropDownBackColor = System.Drawing.Color.FromArgb(CType(CType(193, Byte), Integer), CType(CType(210, Byte), Integer), CType(CType(238, Byte), Integer))
        Me.CboNhomDC.DropDownForeColor = System.Drawing.Color.Black
        Me.CboNhomDC.DropDownStyle = MTGCComboBox.CustomDropDownStyle.DropDown
        Me.CboNhomDC.DropDownWidth = 141
        Me.CboNhomDC.GridLineColor = System.Drawing.Color.LightGray
        Me.CboNhomDC.GridLineHorizontal = False
        Me.CboNhomDC.GridLineVertical = False
        Me.CboNhomDC.LoadingType = MTGCComboBox.CaricamentoCombo.ComboBoxItem
        Me.CboNhomDC.Location = New System.Drawing.Point(501, 70)
        Me.CboNhomDC.ManagingFastMouseMoving = True
        Me.CboNhomDC.ManagingFastMouseMovingInterval = 30
        Me.CboNhomDC.Name = "CboNhomDC"
        Me.CboNhomDC.SelectedItem = Nothing
        Me.CboNhomDC.SelectedValue = Nothing
        Me.CboNhomDC.Size = New System.Drawing.Size(76, 21)
        Me.CboNhomDC.TabIndex = 10
        '
        'TxtTenNhomDC
        '
        Me.TxtTenNhomDC.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtTenNhomDC.Location = New System.Drawing.Point(578, 70)
        Me.TxtTenNhomDC.MaxLength = 10
        Me.TxtTenNhomDC.Name = "TxtTenNhomDC"
        Me.TxtTenNhomDC.Size = New System.Drawing.Size(205, 22)
        Me.TxtTenNhomDC.TabIndex = 85
        '
        'Label13
        '
        Me.Label13.Location = New System.Drawing.Point(401, 71)
        Me.Label13.Name = "Label13"
        Me.Label13.Size = New System.Drawing.Size(100, 20)
        Me.Label13.TabIndex = 86
        Me.Label13.Text = "Nhóm dược chính"
        '
        'TxtChietKhau
        '
        Me.TxtChietKhau.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtChietKhau.Location = New System.Drawing.Point(636, 96)
        Me.TxtChietKhau.MaxLength = 10
        Me.TxtChietKhau.Name = "TxtChietKhau"
        Me.TxtChietKhau.Size = New System.Drawing.Size(148, 22)
        Me.TxtChietKhau.TabIndex = 13
        '
        'Label14
        '
        Me.Label14.Location = New System.Drawing.Point(523, 98)
        Me.Label14.Name = "Label14"
        Me.Label14.Size = New System.Drawing.Size(107, 19)
        Me.Label14.TabIndex = 89
        Me.Label14.Text = "Chiết Khấu ( % )"
        '
        'TabMain
        '
        Me.TabMain.Controls.Add(Me.TabThongTin)
        Me.TabMain.Controls.Add(Me.TabTimKiem)
        Me.TabMain.Location = New System.Drawing.Point(0, 41)
        Me.TabMain.Name = "TabMain"
        Me.TabMain.SelectedIndex = 0
        Me.TabMain.Size = New System.Drawing.Size(980, 593)
        Me.TabMain.TabIndex = 90
        '
        'TabThongTin
        '
        Me.TabThongTin.BackColor = System.Drawing.Color.LightBlue
        Me.TabThongTin.Controls.Add(Me.Label17)
        Me.TabThongTin.Controls.Add(Me.txtDieuKien)
        Me.TabThongTin.Controls.Add(Me.Label15)
        Me.TabThongTin.Controls.Add(Me.txtSDK)
        Me.TabThongTin.Controls.Add(Me.DataGridView1)
        Me.TabThongTin.Controls.Add(Me.TxtChietKhau)
        Me.TabThongTin.Controls.Add(Me.btnSave)
        Me.TabThongTin.Controls.Add(Me.Label14)
        Me.TabThongTin.Controls.Add(Me.btnNew)
        Me.TabThongTin.Controls.Add(Me.CboNhomDC)
        Me.TabThongTin.Controls.Add(Me.btnDelete1)
        Me.TabThongTin.Controls.Add(Me.TxtTenNhomDC)
        Me.TabThongTin.Controls.Add(Me.BtnClose)
        Me.TabThongTin.Controls.Add(Me.Label13)
        Me.TabThongTin.Controls.Add(Me.Button1)
        Me.TabThongTin.Controls.Add(Me.CboNhomHH)
        Me.TabThongTin.Controls.Add(Me.Label2)
        Me.TabThongTin.Controls.Add(Me.TxtDV_Le)
        Me.TabThongTin.Controls.Add(Me.Label3)
        Me.TabThongTin.Controls.Add(Me.TxtQC_Le)
        Me.TabThongTin.Controls.Add(Me.Label4)
        Me.TabThongTin.Controls.Add(Me.TxtDV_Chan)
        Me.TabThongTin.Controls.Add(Me.txtMa_HH)
        Me.TabThongTin.Controls.Add(Me.TxtQC_Chan)
        Me.TabThongTin.Controls.Add(Me.txtTen_BD)
        Me.TabThongTin.Controls.Add(Me.TxtDV_Thung)
        Me.TabThongTin.Controls.Add(Me.txtTen_HD)
        Me.TabThongTin.Controls.Add(Me.TxtQC_Thung)
        Me.TabThongTin.Controls.Add(Me.Label5)
        Me.TabThongTin.Controls.Add(Me.Label12)
        Me.TabThongTin.Controls.Add(Me.TxtTenNhomHH)
        Me.TabThongTin.Controls.Add(Me.Label6)
        Me.TabThongTin.Controls.Add(Me.TxtHanDung)
        Me.TabThongTin.Controls.Add(Me.TxtGiaBan)
        Me.TabThongTin.Controls.Add(Me.Label10)
        Me.TabThongTin.Controls.Add(Me.Label7)
        Me.TabThongTin.Controls.Add(Me.TxtMax)
        Me.TabThongTin.Controls.Add(Me.TxtGiaSYT)
        Me.TabThongTin.Controls.Add(Me.Label9)
        Me.TabThongTin.Controls.Add(Me.Label8)
        Me.TabThongTin.Controls.Add(Me.TxtMin)
        Me.TabThongTin.Location = New System.Drawing.Point(4, 22)
        Me.TabThongTin.Name = "TabThongTin"
        Me.TabThongTin.Padding = New System.Windows.Forms.Padding(3)
        Me.TabThongTin.Size = New System.Drawing.Size(972, 567)
        Me.TabThongTin.TabIndex = 0
        Me.TabThongTin.Text = "Thông tin"
        '
        'Label17
        '
        Me.Label17.Location = New System.Drawing.Point(395, 153)
        Me.Label17.Name = "Label17"
        Me.Label17.Size = New System.Drawing.Size(100, 17)
        Me.Label17.TabIndex = 93
        Me.Label17.Text = "Điều kiện bảo quản"
        '
        'txtDieuKien
        '
        Me.txtDieuKien.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtDieuKien.Location = New System.Drawing.Point(501, 150)
        Me.txtDieuKien.MaxLength = 10000
        Me.txtDieuKien.Name = "txtDieuKien"
        Me.txtDieuKien.Size = New System.Drawing.Size(282, 22)
        Me.txtDieuKien.TabIndex = 18
        '
        'Label15
        '
        Me.Label15.Location = New System.Drawing.Point(70, 151)
        Me.Label15.Name = "Label15"
        Me.Label15.Size = New System.Drawing.Size(62, 17)
        Me.Label15.TabIndex = 91
        Me.Label15.Text = "Số đăng ký"
        '
        'txtSDK
        '
        Me.txtSDK.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtSDK.Location = New System.Drawing.Point(138, 150)
        Me.txtSDK.MaxLength = 10000
        Me.txtSDK.Name = "txtSDK"
        Me.txtSDK.Size = New System.Drawing.Size(257, 22)
        Me.txtSDK.TabIndex = 17
        '
        'TabTimKiem
        '
        Me.TabTimKiem.BackColor = System.Drawing.Color.LightBlue
        Me.TabTimKiem.Controls.Add(Me.Label16)
        Me.TabTimKiem.Controls.Add(Me.txtMaSearch)
        Me.TabTimKiem.Controls.Add(Me.btnTimKiem)
        Me.TabTimKiem.Controls.Add(Me.txtTenSearch)
        Me.TabTimKiem.Controls.Add(Me.Label11)
        Me.TabTimKiem.Controls.Add(Me.gridSearch)
        Me.TabTimKiem.Location = New System.Drawing.Point(4, 22)
        Me.TabTimKiem.Name = "TabTimKiem"
        Me.TabTimKiem.Padding = New System.Windows.Forms.Padding(3)
        Me.TabTimKiem.Size = New System.Drawing.Size(972, 567)
        Me.TabTimKiem.TabIndex = 1
        Me.TabTimKiem.Text = "Tìm kiếm"
        '
        'Label16
        '
        Me.Label16.AutoSize = True
        Me.Label16.Location = New System.Drawing.Point(186, 15)
        Me.Label16.Name = "Label16"
        Me.Label16.Size = New System.Drawing.Size(74, 13)
        Me.Label16.TabIndex = 75
        Me.Label16.Text = "Mã Hàng Hoá"
        '
        'txtMaSearch
        '
        Me.txtMaSearch.Location = New System.Drawing.Point(265, 12)
        Me.txtMaSearch.Name = "txtMaSearch"
        Me.txtMaSearch.Size = New System.Drawing.Size(203, 20)
        Me.txtMaSearch.TabIndex = 74
        '
        'btnTimKiem
        '
        Me.btnTimKiem.Location = New System.Drawing.Point(500, 26)
        Me.btnTimKiem.Name = "btnTimKiem"
        Me.btnTimKiem.Size = New System.Drawing.Size(91, 23)
        Me.btnTimKiem.TabIndex = 73
        Me.btnTimKiem.Text = "Tìm kiếm..."
        Me.btnTimKiem.UseVisualStyleBackColor = True
        '
        'txtTenSearch
        '
        Me.txtTenSearch.Location = New System.Drawing.Point(266, 38)
        Me.txtTenSearch.Name = "txtTenSearch"
        Me.txtTenSearch.Size = New System.Drawing.Size(202, 20)
        Me.txtTenSearch.TabIndex = 72
        '
        'Label11
        '
        Me.Label11.AutoSize = True
        Me.Label11.Location = New System.Drawing.Point(186, 41)
        Me.Label11.Name = "Label11"
        Me.Label11.Size = New System.Drawing.Size(78, 13)
        Me.Label11.TabIndex = 71
        Me.Label11.Text = "Tên Hàng Hoá"
        '
        'gridSearch
        '
        Me.gridSearch.AutoGenerateColumns = False
        Me.gridSearch.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize
        Me.gridSearch.Columns.AddRange(New System.Windows.Forms.DataGridViewColumn() {Me.MahanghoaDataGridViewTextBoxColumn1, Me.TenbietduocDataGridViewTextBoxColumn1, Me.TenhoaduocDataGridViewTextBoxColumn1, Me.DonvithungDataGridViewTextBoxColumn1, Me.QuicachthungDataGridViewTextBoxColumn1, Me.DonvibanchanDataGridViewTextBoxColumn1, Me.QuicachbanchanDataGridViewTextBoxColumn1, Me.DonvibanleDataGridViewTextBoxColumn1, Me.QuicachbanleDataGridViewTextBoxColumn1, Me.DongiaboDataGridViewTextBoxColumn1, Me.DongiabanDataGridViewTextBoxColumn1, Me.ChietkhauDataGridViewTextBoxColumn1, Me.ManhomhanghoaDataGridViewTextBoxColumn1, Me.MaduocchinhDataGridViewTextBoxColumn1, Me.HandungDataGridViewTextBoxColumn1, Me.MinDataGridViewTextBoxColumn1, Me.MaxDataGridViewTextBoxColumn1, Me.DataGridViewTextBoxColumn1, Me.DataGridViewTextBoxColumn2})
        Me.gridSearch.DataMember = "tbl_hanghoaSearch"
        Me.gridSearch.DataSource = Me.DataSetSearchBindingSource
        Me.gridSearch.Location = New System.Drawing.Point(6, 64)
        Me.gridSearch.Name = "gridSearch"
        Me.gridSearch.RowHeadersWidth = 26
        Me.gridSearch.Size = New System.Drawing.Size(966, 500)
        Me.gridSearch.TabIndex = 69
        '
        'MahanghoaDataGridViewTextBoxColumn1
        '
        Me.MahanghoaDataGridViewTextBoxColumn1.DataPropertyName = "ma_hanghoa"
        Me.MahanghoaDataGridViewTextBoxColumn1.HeaderText = "Mã HH"
        Me.MahanghoaDataGridViewTextBoxColumn1.Name = "MahanghoaDataGridViewTextBoxColumn1"
        '
        'TenbietduocDataGridViewTextBoxColumn1
        '
        Me.TenbietduocDataGridViewTextBoxColumn1.DataPropertyName = "ten_bietduoc"
        Me.TenbietduocDataGridViewTextBoxColumn1.HeaderText = "Tên HH"
        Me.TenbietduocDataGridViewTextBoxColumn1.Name = "TenbietduocDataGridViewTextBoxColumn1"
        Me.TenbietduocDataGridViewTextBoxColumn1.Width = 250
        '
        'TenhoaduocDataGridViewTextBoxColumn1
        '
        Me.TenhoaduocDataGridViewTextBoxColumn1.DataPropertyName = "ten_hoaduoc"
        Me.TenhoaduocDataGridViewTextBoxColumn1.HeaderText = "ten_hoaduoc"
        Me.TenhoaduocDataGridViewTextBoxColumn1.Name = "TenhoaduocDataGridViewTextBoxColumn1"
        Me.TenhoaduocDataGridViewTextBoxColumn1.Visible = False
        '
        'DonvithungDataGridViewTextBoxColumn1
        '
        Me.DonvithungDataGridViewTextBoxColumn1.DataPropertyName = "donvi_thung"
        Me.DonvithungDataGridViewTextBoxColumn1.HeaderText = "donvi_thung"
        Me.DonvithungDataGridViewTextBoxColumn1.Name = "DonvithungDataGridViewTextBoxColumn1"
        Me.DonvithungDataGridViewTextBoxColumn1.Visible = False
        '
        'QuicachthungDataGridViewTextBoxColumn1
        '
        Me.QuicachthungDataGridViewTextBoxColumn1.DataPropertyName = "quicach_thung"
        Me.QuicachthungDataGridViewTextBoxColumn1.HeaderText = "quicach_thung"
        Me.QuicachthungDataGridViewTextBoxColumn1.Name = "QuicachthungDataGridViewTextBoxColumn1"
        Me.QuicachthungDataGridViewTextBoxColumn1.Visible = False
        '
        'DonvibanchanDataGridViewTextBoxColumn1
        '
        Me.DonvibanchanDataGridViewTextBoxColumn1.DataPropertyName = "donvi_banchan"
        Me.DonvibanchanDataGridViewTextBoxColumn1.HeaderText = "donvi_banchan"
        Me.DonvibanchanDataGridViewTextBoxColumn1.Name = "DonvibanchanDataGridViewTextBoxColumn1"
        Me.DonvibanchanDataGridViewTextBoxColumn1.Visible = False
        '
        'QuicachbanchanDataGridViewTextBoxColumn1
        '
        Me.QuicachbanchanDataGridViewTextBoxColumn1.DataPropertyName = "quicach_banchan"
        Me.QuicachbanchanDataGridViewTextBoxColumn1.HeaderText = "quicach_banchan"
        Me.QuicachbanchanDataGridViewTextBoxColumn1.Name = "QuicachbanchanDataGridViewTextBoxColumn1"
        Me.QuicachbanchanDataGridViewTextBoxColumn1.Visible = False
        '
        'DonvibanleDataGridViewTextBoxColumn1
        '
        Me.DonvibanleDataGridViewTextBoxColumn1.DataPropertyName = "donvi_banle"
        Me.DonvibanleDataGridViewTextBoxColumn1.HeaderText = "donvi_banle"
        Me.DonvibanleDataGridViewTextBoxColumn1.Name = "DonvibanleDataGridViewTextBoxColumn1"
        Me.DonvibanleDataGridViewTextBoxColumn1.Visible = False
        '
        'QuicachbanleDataGridViewTextBoxColumn1
        '
        Me.QuicachbanleDataGridViewTextBoxColumn1.DataPropertyName = "quicach_banle"
        Me.QuicachbanleDataGridViewTextBoxColumn1.HeaderText = "quicach_banle"
        Me.QuicachbanleDataGridViewTextBoxColumn1.Name = "QuicachbanleDataGridViewTextBoxColumn1"
        Me.QuicachbanleDataGridViewTextBoxColumn1.Visible = False
        '
        'DongiaboDataGridViewTextBoxColumn1
        '
        Me.DongiaboDataGridViewTextBoxColumn1.DataPropertyName = "dongia_bo"
        Me.DongiaboDataGridViewTextBoxColumn1.HeaderText = "dongia_bo"
        Me.DongiaboDataGridViewTextBoxColumn1.Name = "DongiaboDataGridViewTextBoxColumn1"
        Me.DongiaboDataGridViewTextBoxColumn1.Visible = False
        '
        'DongiabanDataGridViewTextBoxColumn1
        '
        Me.DongiabanDataGridViewTextBoxColumn1.DataPropertyName = "dongia_ban"
        Me.DongiabanDataGridViewTextBoxColumn1.HeaderText = "dongia_ban"
        Me.DongiabanDataGridViewTextBoxColumn1.Name = "DongiabanDataGridViewTextBoxColumn1"
        Me.DongiabanDataGridViewTextBoxColumn1.Visible = False
        '
        'ChietkhauDataGridViewTextBoxColumn1
        '
        Me.ChietkhauDataGridViewTextBoxColumn1.DataPropertyName = "chietkhau"
        Me.ChietkhauDataGridViewTextBoxColumn1.HeaderText = "chietkhau"
        Me.ChietkhauDataGridViewTextBoxColumn1.Name = "ChietkhauDataGridViewTextBoxColumn1"
        Me.ChietkhauDataGridViewTextBoxColumn1.Visible = False
        '
        'ManhomhanghoaDataGridViewTextBoxColumn1
        '
        Me.ManhomhanghoaDataGridViewTextBoxColumn1.DataPropertyName = "ma_nhomhanghoa"
        Me.ManhomhanghoaDataGridViewTextBoxColumn1.HeaderText = "ma_nhomhanghoa"
        Me.ManhomhanghoaDataGridViewTextBoxColumn1.Name = "ManhomhanghoaDataGridViewTextBoxColumn1"
        Me.ManhomhanghoaDataGridViewTextBoxColumn1.Visible = False
        '
        'MaduocchinhDataGridViewTextBoxColumn1
        '
        Me.MaduocchinhDataGridViewTextBoxColumn1.DataPropertyName = "ma_duocchinh"
        Me.MaduocchinhDataGridViewTextBoxColumn1.HeaderText = "ma_duocchinh"
        Me.MaduocchinhDataGridViewTextBoxColumn1.Name = "MaduocchinhDataGridViewTextBoxColumn1"
        Me.MaduocchinhDataGridViewTextBoxColumn1.Visible = False
        '
        'HandungDataGridViewTextBoxColumn1
        '
        Me.HandungDataGridViewTextBoxColumn1.DataPropertyName = "handung"
        Me.HandungDataGridViewTextBoxColumn1.HeaderText = "Hạn dùng"
        Me.HandungDataGridViewTextBoxColumn1.Name = "HandungDataGridViewTextBoxColumn1"
        '
        'MinDataGridViewTextBoxColumn1
        '
        Me.MinDataGridViewTextBoxColumn1.DataPropertyName = "min_"
        Me.MinDataGridViewTextBoxColumn1.HeaderText = "min_"
        Me.MinDataGridViewTextBoxColumn1.Name = "MinDataGridViewTextBoxColumn1"
        '
        'MaxDataGridViewTextBoxColumn1
        '
        Me.MaxDataGridViewTextBoxColumn1.DataPropertyName = "max_"
        Me.MaxDataGridViewTextBoxColumn1.HeaderText = "max_"
        Me.MaxDataGridViewTextBoxColumn1.Name = "MaxDataGridViewTextBoxColumn1"
        '
        'DataGridViewTextBoxColumn1
        '
        Me.DataGridViewTextBoxColumn1.DataPropertyName = "sdk"
        Me.DataGridViewTextBoxColumn1.HeaderText = "sdk"
        Me.DataGridViewTextBoxColumn1.Name = "DataGridViewTextBoxColumn1"
        Me.DataGridViewTextBoxColumn1.Visible = False
        '
        'DataGridViewTextBoxColumn2
        '
        Me.DataGridViewTextBoxColumn2.DataPropertyName = "dkbaoquan"
        Me.DataGridViewTextBoxColumn2.HeaderText = "dkbaoquan"
        Me.DataGridViewTextBoxColumn2.Name = "DataGridViewTextBoxColumn2"
        Me.DataGridViewTextBoxColumn2.Visible = False
        '
        'DataSetSearchBindingSource
        '
        Me.DataSetSearchBindingSource.DataSource = Me.DataSetSearch
        Me.DataSetSearchBindingSource.Position = 0
        '
        'DataSetSearch
        '
        Me.DataSetSearch.DataSetName = "DataSetSearch"
        Me.DataSetSearch.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema
        '
        'MahanghoaDataGridViewTextBoxColumn
        '
        Me.MahanghoaDataGridViewTextBoxColumn.DataPropertyName = "ma_hanghoa"
        Me.MahanghoaDataGridViewTextBoxColumn.HeaderText = "Mã HH"
        Me.MahanghoaDataGridViewTextBoxColumn.Name = "MahanghoaDataGridViewTextBoxColumn"
        Me.MahanghoaDataGridViewTextBoxColumn.ReadOnly = True
        Me.MahanghoaDataGridViewTextBoxColumn.Width = 80
        '
        'TenbietduocDataGridViewTextBoxColumn
        '
        Me.TenbietduocDataGridViewTextBoxColumn.DataPropertyName = "ten_bietduoc"
        Me.TenbietduocDataGridViewTextBoxColumn.HeaderText = "Tên HH"
        Me.TenbietduocDataGridViewTextBoxColumn.Name = "TenbietduocDataGridViewTextBoxColumn"
        Me.TenbietduocDataGridViewTextBoxColumn.ReadOnly = True
        Me.TenbietduocDataGridViewTextBoxColumn.Width = 250
        '
        'TenhoaduocDataGridViewTextBoxColumn
        '
        Me.TenhoaduocDataGridViewTextBoxColumn.DataPropertyName = "ten_hoaduoc"
        Me.TenhoaduocDataGridViewTextBoxColumn.HeaderText = "Tên hoá dược"
        Me.TenhoaduocDataGridViewTextBoxColumn.Name = "TenhoaduocDataGridViewTextBoxColumn"
        Me.TenhoaduocDataGridViewTextBoxColumn.ReadOnly = True
        Me.TenhoaduocDataGridViewTextBoxColumn.Visible = False
        '
        'DonvithungDataGridViewTextBoxColumn
        '
        Me.DonvithungDataGridViewTextBoxColumn.DataPropertyName = "donvi_thung"
        Me.DonvithungDataGridViewTextBoxColumn.HeaderText = "donvi_thung"
        Me.DonvithungDataGridViewTextBoxColumn.Name = "DonvithungDataGridViewTextBoxColumn"
        Me.DonvithungDataGridViewTextBoxColumn.ReadOnly = True
        Me.DonvithungDataGridViewTextBoxColumn.Visible = False
        '
        'QuicachthungDataGridViewTextBoxColumn
        '
        Me.QuicachthungDataGridViewTextBoxColumn.DataPropertyName = "quicach_thung"
        Me.QuicachthungDataGridViewTextBoxColumn.HeaderText = "quicach_thung"
        Me.QuicachthungDataGridViewTextBoxColumn.Name = "QuicachthungDataGridViewTextBoxColumn"
        Me.QuicachthungDataGridViewTextBoxColumn.ReadOnly = True
        Me.QuicachthungDataGridViewTextBoxColumn.Visible = False
        '
        'DonvibanchanDataGridViewTextBoxColumn
        '
        Me.DonvibanchanDataGridViewTextBoxColumn.DataPropertyName = "donvi_banchan"
        DataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter
        Me.DonvibanchanDataGridViewTextBoxColumn.DefaultCellStyle = DataGridViewCellStyle1
        Me.DonvibanchanDataGridViewTextBoxColumn.HeaderText = "ĐVT"
        Me.DonvibanchanDataGridViewTextBoxColumn.Name = "DonvibanchanDataGridViewTextBoxColumn"
        Me.DonvibanchanDataGridViewTextBoxColumn.ReadOnly = True
        Me.DonvibanchanDataGridViewTextBoxColumn.Width = 55
        '
        'QuicachbanchanDataGridViewTextBoxColumn
        '
        Me.QuicachbanchanDataGridViewTextBoxColumn.DataPropertyName = "quicach_banchan"
        Me.QuicachbanchanDataGridViewTextBoxColumn.HeaderText = "quicach_banchan"
        Me.QuicachbanchanDataGridViewTextBoxColumn.Name = "QuicachbanchanDataGridViewTextBoxColumn"
        Me.QuicachbanchanDataGridViewTextBoxColumn.ReadOnly = True
        Me.QuicachbanchanDataGridViewTextBoxColumn.Visible = False
        '
        'DonvibanleDataGridViewTextBoxColumn
        '
        Me.DonvibanleDataGridViewTextBoxColumn.DataPropertyName = "donvi_banle"
        Me.DonvibanleDataGridViewTextBoxColumn.HeaderText = "donvi_banle"
        Me.DonvibanleDataGridViewTextBoxColumn.Name = "DonvibanleDataGridViewTextBoxColumn"
        Me.DonvibanleDataGridViewTextBoxColumn.ReadOnly = True
        Me.DonvibanleDataGridViewTextBoxColumn.Visible = False
        '
        'QuicachbanleDataGridViewTextBoxColumn
        '
        Me.QuicachbanleDataGridViewTextBoxColumn.DataPropertyName = "quicach_banle"
        Me.QuicachbanleDataGridViewTextBoxColumn.HeaderText = "quicach_banle"
        Me.QuicachbanleDataGridViewTextBoxColumn.Name = "QuicachbanleDataGridViewTextBoxColumn"
        Me.QuicachbanleDataGridViewTextBoxColumn.ReadOnly = True
        Me.QuicachbanleDataGridViewTextBoxColumn.Visible = False
        '
        'DongiaboDataGridViewTextBoxColumn
        '
        Me.DongiaboDataGridViewTextBoxColumn.DataPropertyName = "dongia_bo"
        Me.DongiaboDataGridViewTextBoxColumn.HeaderText = "dongia_bo"
        Me.DongiaboDataGridViewTextBoxColumn.Name = "DongiaboDataGridViewTextBoxColumn"
        Me.DongiaboDataGridViewTextBoxColumn.ReadOnly = True
        Me.DongiaboDataGridViewTextBoxColumn.Visible = False
        '
        'DongiabanDataGridViewTextBoxColumn
        '
        Me.DongiabanDataGridViewTextBoxColumn.DataPropertyName = "dongia_ban"
        DataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight
        DataGridViewCellStyle2.Format = "N2"
        Me.DongiabanDataGridViewTextBoxColumn.DefaultCellStyle = DataGridViewCellStyle2
        Me.DongiabanDataGridViewTextBoxColumn.HeaderText = "ĐG bán"
        Me.DongiabanDataGridViewTextBoxColumn.Name = "DongiabanDataGridViewTextBoxColumn"
        Me.DongiabanDataGridViewTextBoxColumn.ReadOnly = True
        Me.DongiabanDataGridViewTextBoxColumn.Width = 80
        '
        'ChietkhauDataGridViewTextBoxColumn
        '
        Me.ChietkhauDataGridViewTextBoxColumn.DataPropertyName = "chietkhau"
        DataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight
        Me.ChietkhauDataGridViewTextBoxColumn.DefaultCellStyle = DataGridViewCellStyle3
        Me.ChietkhauDataGridViewTextBoxColumn.HeaderText = "(%) CK"
        Me.ChietkhauDataGridViewTextBoxColumn.Name = "ChietkhauDataGridViewTextBoxColumn"
        Me.ChietkhauDataGridViewTextBoxColumn.ReadOnly = True
        Me.ChietkhauDataGridViewTextBoxColumn.Width = 45
        '
        'ManhomhanghoaDataGridViewTextBoxColumn
        '
        Me.ManhomhanghoaDataGridViewTextBoxColumn.DataPropertyName = "ma_nhomhanghoa"
        DataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter
        Me.ManhomhanghoaDataGridViewTextBoxColumn.DefaultCellStyle = DataGridViewCellStyle4
        Me.ManhomhanghoaDataGridViewTextBoxColumn.HeaderText = "Nhóm HH"
        Me.ManhomhanghoaDataGridViewTextBoxColumn.Name = "ManhomhanghoaDataGridViewTextBoxColumn"
        Me.ManhomhanghoaDataGridViewTextBoxColumn.ReadOnly = True
        Me.ManhomhanghoaDataGridViewTextBoxColumn.Width = 80
        '
        'MaduocchinhDataGridViewTextBoxColumn
        '
        Me.MaduocchinhDataGridViewTextBoxColumn.DataPropertyName = "ma_duocchinh"
        DataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter
        Me.MaduocchinhDataGridViewTextBoxColumn.DefaultCellStyle = DataGridViewCellStyle5
        Me.MaduocchinhDataGridViewTextBoxColumn.HeaderText = "Nhóm DC"
        Me.MaduocchinhDataGridViewTextBoxColumn.Name = "MaduocchinhDataGridViewTextBoxColumn"
        Me.MaduocchinhDataGridViewTextBoxColumn.ReadOnly = True
        Me.MaduocchinhDataGridViewTextBoxColumn.Width = 80
        '
        'HandungDataGridViewTextBoxColumn
        '
        Me.HandungDataGridViewTextBoxColumn.DataPropertyName = "handung"
        DataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight
        Me.HandungDataGridViewTextBoxColumn.DefaultCellStyle = DataGridViewCellStyle6
        Me.HandungDataGridViewTextBoxColumn.HeaderText = "Hạn dùng"
        Me.HandungDataGridViewTextBoxColumn.Name = "HandungDataGridViewTextBoxColumn"
        Me.HandungDataGridViewTextBoxColumn.ReadOnly = True
        Me.HandungDataGridViewTextBoxColumn.Width = 70
        '
        'MinDataGridViewTextBoxColumn
        '
        Me.MinDataGridViewTextBoxColumn.DataPropertyName = "min_"
        DataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight
        Me.MinDataGridViewTextBoxColumn.DefaultCellStyle = DataGridViewCellStyle7
        Me.MinDataGridViewTextBoxColumn.HeaderText = "min_"
        Me.MinDataGridViewTextBoxColumn.Name = "MinDataGridViewTextBoxColumn"
        Me.MinDataGridViewTextBoxColumn.ReadOnly = True
        Me.MinDataGridViewTextBoxColumn.Width = 50
        '
        'MaxDataGridViewTextBoxColumn
        '
        Me.MaxDataGridViewTextBoxColumn.DataPropertyName = "max_"
        DataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight
        Me.MaxDataGridViewTextBoxColumn.DefaultCellStyle = DataGridViewCellStyle8
        Me.MaxDataGridViewTextBoxColumn.HeaderText = "max_"
        Me.MaxDataGridViewTextBoxColumn.Name = "MaxDataGridViewTextBoxColumn"
        Me.MaxDataGridViewTextBoxColumn.ReadOnly = True
        Me.MaxDataGridViewTextBoxColumn.Width = 50
        '
        'sdk
        '
        Me.sdk.DataPropertyName = "sdk"
        Me.sdk.HeaderText = "SĐK"
        Me.sdk.Name = "sdk"
        Me.sdk.ReadOnly = True
        Me.sdk.Width = 60
        '
        'dkbaoquan
        '
        Me.dkbaoquan.DataPropertyName = "dkbaoquan"
        Me.dkbaoquan.HeaderText = "dkbaoquan"
        Me.dkbaoquan.Name = "dkbaoquan"
        Me.dkbaoquan.ReadOnly = True
        Me.dkbaoquan.Visible = False
        '
        'frmHangHoa
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
        Me.BackColor = System.Drawing.Color.LightBlue
        Me.ClientSize = New System.Drawing.Size(982, 633)
        Me.Controls.Add(Me.TabMain)
        Me.Controls.Add(Me.Label1)
        Me.Icon = CType(resources.GetObject("$this.Icon"), System.Drawing.Icon)
        Me.Name = "frmHangHoa"
        Me.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen
        Me.Text = "Danh Muc Hang Hoa"
        CType(Me.DataGridView1, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.DataSetFormDonBindingSource, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.DataSetForm_Don, System.ComponentModel.ISupportInitialize).EndInit()
        Me.TabMain.ResumeLayout(False)
        Me.TabThongTin.ResumeLayout(False)
        Me.TabThongTin.PerformLayout()
        Me.TabTimKiem.ResumeLayout(False)
        Me.TabTimKiem.PerformLayout()
        CType(Me.gridSearch, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.DataSetSearchBindingSource, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.DataSetSearch, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)

    End Sub

#End Region
    Private data1, data2, data3 As DataTable
    Private da As MySqlDataAdapter
    Dim myDT As New DataTable
    Dim strError As String = ""
    Dim myform As Form
    Dim sqlQuery As String = ""
    Dim positionHangHoa As Integer = 0
    Sub SetclearData()
        txtMa_HH.Text = ""
        txtTen_BD.Text = ""
        txtTen_HD.Text = ""
        TxtTenNhomHH.Text = ""
        TxtTenNhomDC.Text = ""
        CboNhomHH.Text = ""
        CboNhomDC.Text = ""
        TxtQC_Thung.Text = "1"
        TxtDV_Thung.Text = "thùng"
        TxtQC_Chan.Text = "30"
        TxtDV_Chan.Text = "hộp"
        TxtQC_Le.Text = "20"
        TxtDV_Le.Text = "gói"
        TxtGiaBan.Text = "0"
        TxtGiaSYT.Text = "0"
        TxtChietKhau.Text = "0"
        TxtHanDung.Text = "12"
        TxtMax.Text = "0"
        TxtMin.Text = "0"
        txtSDK.Text = ""
        txtDieuKien.Text = ""
    End Sub

    Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
        ' Kiểm tra có nhập liệu chưa ?
        If Me.checkInput(txtMa_HH.Text, txtTen_BD.Text) Then
            Dim txtMaNH = Me.txtMa_HH.Text.Trim
            sqlQuery = "SELECT ma_hanghoa FROM tbl_hanghoa WHERE ma_hanghoa  = '" & txtMaNH & "'"
            Dim existedMamon As Integer = moduleDatabaseConn.CheckRecordExisted(sqlQuery)
            If existedMamon = 1 Then ' Update record
                moduleConstants.MessageWarning = " Mã hàng hóa đã tồn tại , bạn có muốn cập nhật không  ?"
                If MessageBox.Show(moduleConstants.MessageWarning, globalVariale.msgTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = MsgBoxResult.Yes Then
                    sqlQuery = "UPDATE tbl_hanghoa  "
                    sqlQuery += "SET "
                    sqlQuery += "ma_hanghoa  = '" & txtMaNH & "'"
                    sqlQuery += ", ten_bietduoc= '" & Me.txtTen_BD.Text.Trim & "'"
                    sqlQuery += ", ten_hoaduoc= '" & Me.txtTen_HD.Text.Trim & "'"
                    sqlQuery += ", donvi_thung= '" & Me.TxtDV_Thung.Text.Trim & "'"
                    sqlQuery += ", quicach_thung= '" & Me.TxtQC_Thung.Text.Trim & "'"
                    sqlQuery += ", donvi_banchan= '" & Me.TxtDV_Chan.Text.Trim & "'"
                    sqlQuery += ", quicach_banchan= '" & Me.TxtQC_Chan.Text.Trim & "'"
                    sqlQuery += ", donvi_banle= '" & Me.TxtDV_Le.Text.Trim & "'"
                    sqlQuery += ", quicach_banle= '" & Me.TxtQC_Le.Text.Trim & "'"
                    sqlQuery += ", dongia_bo= '" & Me.TxtGiaSYT.Text.Trim & "'"
                    sqlQuery += ", dongia_ban= '" & Me.TxtGiaBan.Text.Trim & "'"
                    sqlQuery += ", chietkhau= '" & Me.TxtChietKhau.Text.Trim & "'"
                    sqlQuery += ", ma_nhomhanghoa= '" & Me.CboNhomHH.Text.Trim & "'"
                    sqlQuery += ", ma_duocchinh= '" & Me.CboNhomDC.Text.Trim & "'"
                    sqlQuery += ", handung= '" & Me.TxtHanDung.Text.Trim & "'"
                    sqlQuery += ", min_ = '" & Me.TxtMin.Text.Trim & "'"
                    sqlQuery += ", max_ = '" & Me.TxtMax.Text.Trim & "'"
                    sqlQuery += ", sdk = '" & Me.txtSDK.Text.Trim & "'"
                    sqlQuery += ", dkbaoquan = '" & Me.txtDieuKien.Text.Trim & "'"
                    sqlQuery += " WHERE ma_hanghoa = '" & txtMaNH & "'"
                    Dim updated As Integer = moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                    If updated = 1 Then
                        'Khanh Ky 2008 11 28
                        'add Cập nhật phần theo dõi thao tac
                        sqlQuery = "INSERT INTO tbl_theodoi_thaotac_users (user,thaotac,thoigian,tenbang,maphieu,loaibang) VALUES ("
                        sqlQuery += "'" & globalVariale.UserLogin & "', "
                        sqlQuery += "'cập nhật', "
                        sqlQuery += "'" & Format(New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, Now.Minute, Now.Second), "yyyy-MM-dd hh:mm:ss") & "', "
                        sqlQuery += "'Danh Mục Hàng Hóa', "
                        sqlQuery += "'" & Me.txtMa_HH.Text & "', "
                        sqlQuery += "'5' ) "
                        moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                        'end
                        MessageBox.Show("Cập nhật thông tin thành công !")
                        sqlQuery = "SELECT * FROM tbl_hanghoa"
                        Me.loadDanhSachHangHoa(sqlQuery)
                    Else
                        MessageBox.Show("Cập nhật thông tin không thành công: " & globalVariale.sqlMsgError)
                    End If
                End If
            Else
                If existedMamon = 0 Then ' Insert record
                    sqlQuery = "INSERT INTO tbl_hanghoa "
                    sqlQuery += "(ma_hanghoa, ten_bietduoc,ten_hoaduoc,donvi_thung,quicach_thung,donvi_banchan,quicach_banchan,donvi_banle,quicach_banle,dongia_bo,dongia_ban,chietkhau,ma_nhomhanghoa,ma_duocchinh,handung,min_,max_,sdk,dkbaoquan)"
                    sqlQuery += "VALUES "
                    sqlQuery += "("
                    sqlQuery += "'" & txtMaNH.ToUpper & "', "
                    sqlQuery += " '" & Me.txtTen_BD.Text.Trim & "',"
                    sqlQuery += "  '" & Me.txtTen_HD.Text.Trim & "',"
                    sqlQuery += " '" & Me.TxtDV_Thung.Text.Trim & "',"
                    sqlQuery += "  '" & Me.TxtQC_Thung.Text.Trim & "',"
                    sqlQuery += "  '" & Me.TxtDV_Chan.Text.Trim & "',"
                    sqlQuery += "  '" & Me.TxtQC_Chan.Text.Trim & "',"
                    sqlQuery += " '" & Me.TxtDV_Le.Text.Trim & "',"
                    sqlQuery += " '" & Me.TxtQC_Le.Text.Trim & "',"
                    sqlQuery += " '" & Me.TxtGiaSYT.Text.Trim & "',"
                    sqlQuery += " '" & Me.TxtGiaBan.Text.Trim & "',"
                    sqlQuery += " '" & Me.TxtChietKhau.Text.Trim & "',"
                    sqlQuery += " '" & Me.CboNhomHH.Text.Trim & "',"
                    sqlQuery += " '" & Me.CboNhomDC.Text.Trim & "',"
                    sqlQuery += " '" & Me.TxtHanDung.Text.Trim & "',"
                    sqlQuery += " '" & Me.TxtMin.Text.Trim & "',"
                    sqlQuery += " '" & Me.TxtMax.Text.Trim & "',"
                    sqlQuery += " '" & Me.txtSDK.Text.Trim & "',"
                    sqlQuery += " '" & Me.txtDieuKien.Text.Trim & "'"
                    sqlQuery += ")"
                    Dim inserted As Integer = moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                    If inserted = 1 Then
                        'Khanh Ky 2008 11 28
                        'add Cập nhật phần theo dõi thao tac
                        sqlQuery = "INSERT INTO tbl_theodoi_thaotac_users (user,thaotac,thoigian,tenbang,maphieu,loaibang) VALUES ("
                        sqlQuery += "'" & globalVariale.UserLogin & "', "
                        sqlQuery += "'Tạo mới', "
                        sqlQuery += "'" & Format(New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, Now.Minute, Now.Second), "yyyy-MM-dd hh:mm:ss") & "', "
                        sqlQuery += "'Danh Mục Hàng Hóa', "
                        sqlQuery += "'" & Me.txtMa_HH.Text & "', "
                        sqlQuery += "'5' ) "
                        moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                        'end
                        MessageBox.Show("Thêm thông tin thành công !")
                        sqlQuery = "SELECT * FROM tbl_hanghoa"
                        Me.loadDanhSachHangHoa(sqlQuery)
                        Me.SetclearData()
                    Else
                        MessageBox.Show("Thêm thông tin không thành công: " & globalVariale.sqlMsgError)
                    End If
                Else ' SQLExeption: existedMaQuocGia = -1
                    MessageBox.Show("Lấy dữ liệu bị lỗi: " & globalVariale.sqlMsgError, "Lấy dữ liệu", MessageBoxButtons.OK, MessageBoxIcon.Warning)
                End If
            End If
        End If


    End Sub

    Private Sub btnNew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNew.Click
        SetclearData()
        txtMa_HH.Focus()
    End Sub


    Private Sub btnDelete1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete1.Click
        Dim txtMaNH As String = Trim(Me.txtMa_HH.Text)
        If txtMaNH = "" Then
            MessageBox.Show("Bạn chưa chọn Mã để xóa !")
        Else
            Dim txtTenNH As String = Trim(Me.txtTen_BD.Text)


            moduleConstants.MessageWarning = "Bạn có muốn xóa " & txtMaNH & "(" & txtTenNH & ") ?"
            If MessageBox.Show(moduleConstants.MessageWarning, globalVariale.msgTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = MsgBoxResult.Yes Then
                'Khanh Ky 2008 11 28
                'add Cập nhật phần theo dõi thao tac
                sqlQuery = "INSERT INTO tbl_theodoi_thaotac_users (user,thaotac,thoigian,tenbang,maphieu,loaibang) VALUES ("
                sqlQuery += "'" & globalVariale.UserLogin & "', "
                sqlQuery += "'Xóa', "
                sqlQuery += "'" & Format(New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, Now.Minute, Now.Second), "yyyy-MM-dd hh:mm:ss") & "', "
                sqlQuery += "'Danh Mục Hàng Hóa', "
                sqlQuery += "'" & Me.txtMa_HH.Text & "', "
                sqlQuery += "'5' ) "
                moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                'end
                sqlQuery = "DELETE FROM tbl_hanghoa WHERE ma_hanghoa = '" & txtMaNH & "'"
                Dim deleting As Integer = moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                If deleting = 1 Then
                    MessageBox.Show("Xóa thông tin thành công !")
                    sqlQuery = "SELECT * FROM tbl_hanghoa"
                    Me.loadDanhSachHangHoa(sqlQuery)
                    SetclearData()
                Else
                    MessageBox.Show("Xóa thông tin không thành công: " & globalVariale.sqlMsgError)
                End If
            End If
        End If
    End Sub

    Private Sub frmHangHoa_load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
        moduleUtils.setDinhDangVietNam()
        Me.loadDanhSachHangHoa("SELECT * FROM tbl_hanghoa where ma_nhomhanghoa = '" & CboNhomHH.Text & "'")
        Me.loadDanhSachNhomHH()
        Me.loadDanhSachNhomDC()

    End Sub

    Private Sub BtnClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnClose.Click
        Me.Close()
    End Sub

    Function checkInput(ByVal ma As String, ByVal ten As String) As Boolean
        Dim result As Boolean = True
        If ma = "" Then
            MessageBox.Show("Bạn chưa nhập Mã  !")
            result = False
        Else
            If ten = "" Then
                MessageBox.Show("Bạn chưa nhập tên  !")
                result = False
            End If
        End If
        Return result
    End Function

    Private Sub loadDanhSachHangHoa(ByVal sqlQuery As String)
        data3 = moduleDatabaseConn.GetDataTable(sqlQuery)
        Me.DataGridView1.DataSource = data3
    End Sub
    Private Sub loadDanhSachNhomHH()
        Dim sqlQuery As String = ""
        sqlQuery = "SELECT ma_nhom_hanghoa, ten_nhom_hanghoa FROM tbl_nhom_hanghoa ORDER BY ma_nhom_hanghoa"
        data1 = moduleDatabaseConn.GetDataTable(sqlQuery)
        CboNhomHH.Items.Clear()
        CboNhomHH.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        CboNhomHH.ColumnNum = 2
        CboNhomHH.ColumnWidth = "100;250"
        CboNhomHH.HighlightBorderColor = Color.Black
        CboNhomHH.GridLineHorizontal = True
        CboNhomHH.GridLineVertical = True
        CboNhomHH.ItemHeight = 17
        CboNhomHH.DropDownHeight = 300
        CboNhomHH.SourceDataTable = data1
        CboNhomHH.SelectedIndex = 0
    End Sub

    Private Sub CboNhomHH_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CboNhomHH.SelectedIndexChanged
        Me.TxtTenNhomHH.Text = Me.CboNhomHH.SelectedItem.Col2
        sqlQuery = "SELECT * FROM tbl_hanghoa where ma_nhomhanghoa = '" & CboNhomHH.Text & "'"
        DataGridView1.DataSource = moduleDatabaseConn.GetDataTable(sqlQuery)
    End Sub
    Private Sub loadDanhSachNhomDC()
        Dim sqlQuery As String = ""
        sqlQuery = "SELECT ma_nhom_duocchinh, ten_nhom_duocchinh FROM tbl_nhom_duocchinh ORDER BY ma_nhom_duocchinh"
        data2 = moduleDatabaseConn.GetDataTable(sqlQuery)
        CboNhomDC.Items.Clear()
        CboNhomDC.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        CboNhomDC.ColumnNum = 2
        CboNhomDC.ColumnWidth = "100;250"
        CboNhomDC.HighlightBorderColor = Color.Black
        CboNhomDC.GridLineHorizontal = True
        CboNhomDC.GridLineVertical = True
        CboNhomDC.ItemHeight = 17
        CboNhomDC.DropDownHeight = 300
        CboNhomDC.SourceDataTable = data2
        CboNhomDC.SelectedIndex = 0
    End Sub
    Private Sub CboNhomDC_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CboNhomDC.SelectedIndexChanged
        Me.TxtTenNhomDC.Text = Me.CboNhomDC.SelectedItem.Col2
    End Sub

    Private Sub DataGridView1_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellClick

        If e.RowIndex >= 0 Then
            Dim iRow As Integer = Me.DataGridView1.CurrentRow.Index
            Me.txtMa_HH.Text = Me.DataGridView1.Item(0, iRow).Value
            Me.txtTen_BD.Text = Me.DataGridView1.Item(1, iRow).Value
            Me.txtTen_HD.Text = Me.DataGridView1.Item(2, iRow).Value
            Me.TxtDV_Thung.Text = Me.DataGridView1.Item(3, iRow).Value
            Me.TxtQC_Thung.Text = Me.DataGridView1.Item(4, iRow).Value
            Me.TxtDV_Chan.Text = Me.DataGridView1.Item(5, iRow).Value
            Me.TxtQC_Chan.Text = Me.DataGridView1.Item(6, iRow).Value
            Me.TxtDV_Le.Text = Me.DataGridView1.Item(7, iRow).Value
            Me.TxtQC_Le.Text = Me.DataGridView1.Item(8, iRow).Value
            Me.TxtGiaSYT.Text = Me.DataGridView1.Item(9, iRow).Value
            Me.TxtGiaBan.Text = Me.DataGridView1.Item(10, iRow).Value
            Me.TxtChietKhau.Text = Me.DataGridView1.Item(11, iRow).Value
            Me.CboNhomHH.Text = Me.DataGridView1.Item(12, iRow).Value
            Me.CboNhomDC.Text = Me.DataGridView1.Item(13, iRow).Value
            Me.TxtHanDung.Text = Me.DataGridView1.Item(14, iRow).Value
            Me.TxtMin.Text = Me.DataGridView1.Item(15, iRow).Value
            Me.TxtMax.Text = Me.DataGridView1.Item(16, iRow).Value
            Me.txtSDK.Text = Me.DataGridView1.Item(17, iRow).Value
            Me.txtDieuKien.Text = Me.DataGridView1.Item(18, iRow).Value
        End If


    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim report As FrmCrHangHoa = New FrmCrHangHoa
        report.setTrang(5)
        report.Show()
    End Sub

    Private Sub btnTimKiem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTimKiem.Click

        If Me.txtMaSearch.Text = "" And Me.txtTenSearch.Text = "" Then
            MessageBox.Show("Bạn phải nhập thông tin tìm kiếm !!!")
            Me.txtMaSearch.Focus()
        Else
            sqlQuery = "SELECT *  FROM tbl_hanghoa "
            sqlQuery += " where ma_hanghoa like '%" & Me.txtMaSearch.Text & "%'"
            sqlQuery += " and  ten_bietduoc like '%" & Me.txtTenSearch.Text & "%'"
            Me.gridSearch.DataSource = moduleDatabaseConn.GetDataTable(sqlQuery)
        End If


    End Sub

    Private Sub gridSearch_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles gridSearch.DoubleClick
        Me.TabMain.SelectedTab = Me.TabThongTin

        Dim iRow As Integer = Me.gridSearch.CurrentRow.Index
        Me.txtMa_HH.Text = Me.gridSearch.Item(0, iRow).Value
        Me.txtTen_BD.Text = Me.gridSearch.Item(1, iRow).Value
        Me.txtTen_HD.Text = Me.gridSearch.Item(2, iRow).Value
        Me.TxtDV_Thung.Text = Me.gridSearch.Item(3, iRow).Value
        Me.TxtQC_Thung.Text = Me.gridSearch.Item(4, iRow).Value
        Me.TxtDV_Chan.Text = Me.gridSearch.Item(5, iRow).Value
        Me.TxtQC_Chan.Text = Me.gridSearch.Item(6, iRow).Value
        Me.TxtDV_Le.Text = Me.gridSearch.Item(7, iRow).Value
        Me.TxtQC_Le.Text = Me.gridSearch.Item(8, iRow).Value
        Me.TxtGiaSYT.Text = Me.gridSearch.Item(9, iRow).Value
        Me.TxtGiaBan.Text = Me.gridSearch.Item(10, iRow).Value
        Me.TxtChietKhau.Text = Me.gridSearch.Item(11, iRow).Value
        Me.CboNhomHH.Text = Me.gridSearch.Item(12, iRow).Value
        Me.CboNhomDC.Text = Me.gridSearch.Item(13, iRow).Value
        Me.TxtHanDung.Text = Me.gridSearch.Item(14, iRow).Value
        Me.TxtMin.Text = Me.gridSearch.Item(15, iRow).Value
        Me.TxtMax.Text = Me.gridSearch.Item(16, iRow).Value
        Me.txtSDK.Text = Me.gridSearch.Item(17, iRow).Value
        Me.txtDieuKien.Text = Me.gridSearch.Item(18, iRow).Value
        Me.gridSearch.DataSource = New DataTable
    End Sub

    Private Sub loadToFormThongTin(ByVal txtMaHangHoa As String)
        sqlQuery = "SELECT * FROM tbl_hanghoa "
        sqlQuery += " where ma_hanghoa = '" & txtMaHangHoa & "'"
        Dim tmp As DataTable = moduleDatabaseConn.GetDataTable(sqlQuery)
        Try
            Me.txtMa_HH.Text = txtMaHangHoa
            Me.txtTen_BD.Text = tmp.Rows.Item(0).Item(1)
            Me.txtTen_HD.Text = tmp.Rows.Item(0).Item(2)
            Me.TxtDV_Thung.Text = tmp.Rows.Item(0).Item(3)
            Me.TxtQC_Thung.Text = tmp.Rows.Item(0).Item(4)
            Me.TxtDV_Chan.Text = tmp.Rows.Item(0).Item(5)
            Me.TxtQC_Chan.Text = tmp.Rows.Item(0).Item(6)
            Me.TxtDV_Le.Text = tmp.Rows.Item(0).Item(7)
            Me.TxtQC_Le.Text = tmp.Rows.Item(0).Item(8)
            Me.TxtGiaSYT.Text = tmp.Rows.Item(0).Item(9)
            Me.TxtGiaBan.Text = tmp.Rows.Item(0).Item(10)
            Me.TxtChietKhau.Text = tmp.Rows.Item(0).Item(11)
            Me.CboNhomHH.SelectedIndex = getIndex(data1, Me.CboNhomHH, tmp.Rows.Item(0).Item(12))
            'Me.CboNhomHH.Text = 
            Me.CboNhomDC.Text = tmp.Rows.Item(0).Item(13)
            Me.TxtHanDung.Text = tmp.Rows.Item(0).Item(14)
            Me.TxtMin.Text = tmp.Rows.Item(0).Item(15)
            Me.TxtMax.Text = tmp.Rows.Item(0).Item(16)
        Catch ex As Exception
        End Try
    End Sub
    Function getIndex(ByVal data As DataTable, ByVal cbo As ComboBox, ByVal ma As String)
        Dim index As Integer = 0
        For i As Integer = 0 To data.Rows.Count
            If ma = data.Rows.Item(i).Item(0) Then
                positionHangHoa = i
                index = i
                cbo.SelectedIndex = index
            End If
        Next
        Return index
    End Function
End Class


